Purpose
Keep track of status of krypto portfolio over time, based on transactions combined with current price data.
- Import krypto transaction data from spreadsheet.
- Download latest price data.
- Combine to calculate theoretical profit/loss trends.
- by currency
- overall portfolio
Method
- Log into crypto account.
- Download activity report.
- Go to spreadsheet in Marengo - check most recent transaction date there.
- Copy/paste new transactions from activity report.
- Copy down formulas in spreadsheet.
Bitcoin
|
date
|
symb
|
acb
|
price_close
|
diff
|
|
2022-01-30
|
BTC-CAD
|
$48,537.86
|
$48,383.36
|
-0.32%
|
Transactions & Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
- Get latest price data.
- Combine with cost data.
- Calculate profit and ROI.
Ethereum
|
date
|
symb
|
acb
|
price_close
|
diff
|
|
2022-01-30
|
ETH-CAD
|
$1,837.04
|
$3,322.06
|
80.84%
|
Transactions & Adjusted Cost Base (Avg Cost)
Cardano
|
date
|
symb
|
acb
|
price_close
|
diff
|
|
2022-01-30
|
ADA-CAD
|
$2.49
|
$1.32
|
-46.74%
|
Transactions & Adjusted Cost Base (Avg Cost)
Polkadot
|
date
|
symb
|
acb
|
price_close
|
diff
|
|
2022-01-30
|
DOT-CAD
|
$36.23
|
$23.19
|
-36.00%
|
Transactions & Adjusted Cost Base (Avg Cost)
Litecoin
|
date
|
symb
|
acb
|
price_close
|
diff
|
|
2022-01-30
|
LTC-CAD
|
$228.96
|
$138.83
|
-39.36%
|
Transactions & Adjusted Cost Base (Avg Cost)
PRICE-COST SMRY

|
date
|
symb
|
acb
|
price_close
|
diff
|
|
2022-01-30
|
BTC-CAD
|
$48,537.86
|
$48,383.36
|
-0.32%
|
|
2022-01-30
|
ETH-CAD
|
$1,837.04
|
$3,322.06
|
80.84%
|
|
2022-01-30
|
ADA-CAD
|
$2.49
|
$1.32
|
-46.74%
|
|
2022-01-30
|
DOT-CAD
|
$36.23
|
$23.19
|
-36.00%
|
|
2022-01-30
|
LTC-CAD
|
$228.96
|
$138.83
|
-39.36%
|
TOTALS - Returns

|
date
|
currency
|
book_val
|
market_val
|
profit
|
roi
|
|
2022-01-30
|
BTC
|
$3,396
|
$3,385
|
(11)
|
-0%
|
|
2022-01-30
|
ETH
|
$6,998
|
$12,656
|
5,657
|
81%
|
|
2022-01-30
|
ADA
|
$6,711
|
$3,574
|
(3,136)
|
-47%
|
|
2022-01-30
|
DOT
|
$3,043
|
$1,948
|
(1,095)
|
-36%
|
|
2022-01-30
|
LTC
|
$2,305
|
$1,398
|
(907)
|
-39%
|
|
date
|
total_invested
|
total_market_val
|
total_profit
|
total_roi
|
|
2022-01-30
|
$22,453
|
$22,961
|
$508
|
2%
|